<?php
/**
 *comment 表的操作类，继承基础模型类
 */
 class commentModel extends model{
	 /**
	 *添加留言
	 */
	 public function insert(){
		 //输入过滤
		 $this->filter(array('poster','mail','comment'),'htmlspecialchars');
		 $this->filter(array('comment'),'nl2br');
		 //接收输入数据
		 $data['poster']=$_POST['poster'];
		 $data['mail']=$_POST['mail'];
		 $data['comment']=$_POST['comment'];
		 //为其它字段赋值
		 $data['reply']='';
		 $data['date']=date('Y-m-d H:i:s');
		 $data['ip']=$_SERVER['REMOTE_ADDR'];
		 //拼接SQL语句
		 $sql ="insert into comment set ";
		 foreach($data as $k=>$v){
			 $sql.="$k=:$k,";
	 }
	     $sql= rtrim($sql,',');//删除最右边的逗号
		 //通过预处理执行SQL
		 $this->db->execute($sql,$data,$flag);
		 //返回是否执行成功
		 return $flag;
		 //执行SQL并返回
		 return $this->db->query($sql);;
	 }
    /**
	*留言列表
    */
   public function getAll($limit){
         //获得排序参数
         $order='';
         if(isset($_GET['sort'])&& $_GET['sort']=='desc'){
               $order='order by id desc';
		 }
         //拼接SQL
         $sql ="select poster,comment,date,reply from comment $order limit $limit";
         //查询结果
         $data=$this->db->fetchAll($sql);
         return $data;
   }
   /**
    *留言总数
    */
    public function getNumber(){
       $data= $this->db->fetchRow("select count(*)from comment");
       return $data['count(*)'];
   }
 }
   ?>